Pawel Bujnowski

https://ask.libreoffice.org › calc-basic-runtime-error-property-or-method-…
Libre office 25 2 3 2 Spreadsheet MacOS 15 5 BASIC runtime error Property or method not found I m getting the above error It prevents me from accessing the file

https://ask.libreoffice.org › passing-cell-reference-to-basic-function
I really don t know why you are wrapping all of the Calc functions with your own code It seems to me off hand that it would be more advised to create good Named Ranges

https://ask.libreoffice.org › how-to-retrieve-a-cell-value-using-libreoffice-…
In CALC I want to retrieve a cell value change the cell s style property NB without relying on predefined styles depending on that value and write the whole back again

https://ask.libreoffice.org › calc-macro-basic-syntax-error-expected-sub
Hi I have started to use Macros in Calc I get a failure message during the compiling which I cannot solve Any sugestions I know it will be a stupid one The macro

https://ask.libreoffice.org › does-libreoffice-calc-basic-have-inverse-sin-a…
LibreOffice Calc basic seems to have just one inverse trig function atn for arctan arcsin and arccos etc or their equivalents seem to unavailable Suggestions welcomed

https://ask.libreoffice.org › calc-basic-syntax-error-expected-again
It s uncommon to use RC addressing in Calc e g The macro module you pasted your macro in for usage with your stock trading sheet seems to have the option VBAsupport

https://ask.libreoffice.org › looking-for-last-row-used-programmatically
Hello I ve been searching for a property to show the number of rows and columns used I want to loop through data on the sheet but not the entire sheet itself I also want to

https://ask.libreoffice.org › basic-calc-how-to-get-address-of-last-cell-use…
Please note that there isn t a single CellFlag for number in the ordinary sense Calc uses the term DateTime is treated differently based on the category of the

https://ask.libreoffice.org › basic-calc-how-to-check-blank-cell-quickly
From this sheet I did The first data row must not be blank i 0 For c 0 To 2 If c 0 And oSheet GetCellByPosition c 1 Value 0 Then i i 1 If c 1 And